// 云函数入口文件
const cloud = require('wx-server-sdk')

cloud.init({
  env: 'cloud1-5glocnmp62950062'
})
const db = cloud.database()
const $ = db.command.aggregate
const _ = db.command
// 云函数入口函数
exports.main = async (event, context) => {
  const wxContext = cloud.getWXContext()
  let openid = wxContext.OPENID
  const teamlistResult = await db.collection('teamlist').
  aggregate().match({
    _openid:openid
  }).lookup({
    from: 'applications',
    let: {
      team_id: '$_id',
    },
    pipeline: $.pipeline()
    .match(_.expr($.and([
      $.eq(['$teamid', '$$team_id']),
      $.eq(['$approval', 0]),
    ]))).done(),
    as: 'applymember'
  }).end()
  return {
    event,
    teamlistResult,
    openid: wxContext.OPENID
  }
}